Tabela BloodDetails

Definicja tabeli BloodDetails

Name

BloodDetails

Code

BloodDetails

Comment

Tabela przechowujaca dodatkowe parametry donacji lub preparatu krwi.


Lista kolumn tabeli BloodDetails

Name

Code

BloodDetailsID

BloodDetailsID

ResourceID

ResourceID

DictionaryValueID

DictionaryValueID

Dic_DictionaryValueID

Dic_DictionaryValueID

Dic_DictionaryValueID2

Dic_DictionaryValueID2

BloodGroup

BloodGroup

Phenotype

Phenotype

ProductNumber

ProductNumber

Division

Division

CrossMatchNeeded

CrossMatchNeeded

Autologous

Autologous

Biohazard

Biohazard

BloodGroupISBT

BloodGroupISBT

Directed

Directed

UnitPrice

UnitPrice

Volume

Volume

VolumeUnitID

VolumeUnitID

LabelPhoto

LabelPhoto

LabelPhotoFileName

LabelPhotoFileName

ProducingOrganization

ProducingOrganization

BloodDonorCode

BloodDonorCode

DeliveryDate

DeliveryDate

Returned

Returned


Kolumna BloodDetailsID tabeli BloodDetails

Definicja kolumny BloodDetailsID tabeli BloodDetails

Name

BloodDetailsID

Code

BloodDetailsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli BloodDetails

Definicja kolumny ResourceID tabeli BloodDetails

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DictionaryValueID tabeli BloodDetails

Definicja kolumny DictionaryValueID tabeli BloodDetails

Name

DictionaryValueID

Code

DictionaryValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Dic_DictionaryValueID tabeli BloodDetails

Definicja kolumny Dic_DictionaryValueID tabeli BloodDetails

Name

Dic_DictionaryValueID

Code

Dic_DictionaryValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Dic_DictionaryValueID2 tabeli BloodDetails

Definicja kolumny Dic_DictionaryValueID2 tabeli BloodDetails

Name

Dic_DictionaryValueID2

Code

Dic_DictionaryValueID2

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BloodGroup tabeli BloodDetails

Definicja kolumny BloodGroup tabeli BloodDetails

Name

BloodGroup

Code

BloodGroup

Data Type

VARCHAR2(255)

Mandatory

No

Comment

"Materializowana" wartosc ze slownika grupy krwi


Kolumna Phenotype tabeli BloodDetails

Definicja kolumny Phenotype tabeli BloodDetails

Name

Phenotype

Code

Phenotype

Data Type

VARCHAR2(255)

Mandatory

No

Comment

"Materializowana" wartosc ze slownika fenotyp


Kolumna ProductNumber tabeli BloodDetails

Definicja kolumny ProductNumber tabeli BloodDetails

Name

ProductNumber

Code

ProductNumber

Data Type

VARCHAR2(5)

Mandatory

No

Comment

Numer produktu (ICCBBA/ISBT128)


Kolumna Division tabeli BloodDetails

Definicja kolumny Division tabeli BloodDetails

Name

Division

Code

Division

Data Type

VARCHAR2(2)

Mandatory

No

Comment

Informacje o podziale donacji na porcje (koniec l.doln. kodu ISBT)


Kolumna CrossMatchNeeded tabeli BloodDetails

Definicja kolumny CrossMatchNeeded tabeli BloodDetails

Name

CrossMatchNeeded

Code

CrossMatchNeeded

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Autologous tabeli BloodDetails

Definicja kolumny Autologous tabeli BloodDetails

Name

Autologous

Code

Autologous

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Biohazard tabeli BloodDetails

Definicja kolumny Biohazard tabeli BloodDetails

Name

Biohazard

Code

Biohazard

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna BloodGroupISBT tabeli BloodDetails

Definicja kolumny BloodGroupISBT tabeli BloodDetails

Name

BloodGroupISBT

Code

BloodGroupISBT

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna Directed tabeli BloodDetails

Definicja kolumny Directed tabeli BloodDetails

Name

Directed

Code

Directed

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UnitPrice tabeli BloodDetails

Definicja kolumny UnitPrice tabeli BloodDetails

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

cena jednostki krwi


Kolumna Volume tabeli BloodDetails

Definicja kolumny Volume tabeli BloodDetails

Name

Volume

Code

Volume

Data Type

NUMBER(12,4)

Mandatory

No

Comment

objetosc preparatu krwi


Kolumna VolumeUnitID tabeli BloodDetails

Definicja kolumny VolumeUnitID tabeli BloodDetails

Name

VolumeUnitID

Code

VolumeUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

jednostka w jakich wyrazone jest pole Volume


Kolumna LabelPhoto tabeli BloodDetails

Definicja kolumny LabelPhoto tabeli BloodDetails

Name

LabelPhoto

Code

LabelPhoto

Data Type

BLOB

Mandatory

No

Comment

zdjecie naklejki


Kolumna LabelPhotoFileName tabeli BloodDetails

Definicja kolumny LabelPhotoFileName tabeli BloodDetails

Name

LabelPhotoFileName

Code

LabelPhotoFileName

Data Type

VARCHAR2(100)

Mandatory

No

Comment

nazwa pliku naklejki


Kolumna ProducingOrganization tabeli BloodDetails

Definicja kolumny ProducingOrganization tabeli BloodDetails

Name

ProducingOrganization

Code

ProducingOrganization

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Organizacja która wytworzyla krew


Kolumna BloodDonorCode tabeli BloodDetails

Definicja kolumny BloodDonorCode tabeli BloodDetails

Name

BloodDonorCode

Code

BloodDonorCode

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Kod dawcy krwi


Kolumna DeliveryDate tabeli BloodDetails

Definicja kolumny DeliveryDate tabeli BloodDetails

Name

DeliveryDate

Code

DeliveryDate

Data Type

DATE

Mandatory

No

Comment

Data dostarczenia na oddzial


Kolumna Returned tabeli BloodDetails

Definicja kolumny Returned tabeli BloodDetails

Name

Returned

Code

Returned

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Czy dany preparat krwi byl zwrócony do jednostki nadrzednej (banku krwi)


Lista kluczy tabeli BloodDetails

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli BloodDetails

Definicja klucza Identifier_1 tabeli BloodDetails

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment